HeteroDrive: Reshaping the Storage Access Pattern of OLTP Workload Using SSD

نویسندگان

  • Sang-Hoon Kim
  • Dawoon Jung
  • Jin-Soo Kim
  • Seungryoul Maeng
چکیده

The on-line transaction processing (OLTP) workload is known to produce intense random accesses with high ratio of write. Coping with the random access pattern has been a challenging issue to the underlying storage system. Although SSDs are considered as a breakthrough in storage systems, their random write performance still falls far behind the sequential performance. In this paper, we propose a hybrid storage architecture, HeteroDrive. HeteroDrive actively reshapes random writes to sequential writes. Random writes are routed to SSD and written sequentially. The large capacity of SSD is used as a cache while the contents are flushed to HDD sequentially. According to our evaluation, HeteroDrive improves the transactions per second (TPS) by up to 201 %.

برای دانلود رایگان متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

منابع مشابه

Research on Performance Optimization of Oltp Systems Based on Innodb

The technology of flash memory SSDs (solid state drives) which are increasingly adopted in a wide spectrum of storage systems has the potential of changing the database architecture and principles. With the high random access speed and high IOPS of the SSD, this paper describes a secondary buffer pool & readahead solution based on OLTP for MySQL InnoDB which can reduce I/O requests & latency an...

متن کامل

Page Size Selection for OLTP Databases on SSD RAID Storage

Abstract. Flash SSDs are a technology that has the potential of changing the database architecture and principles. We reevaluate the present trend of growing database page sizes considering its validity for SSD-based database storage. Our major findings are: (a) on Flash storage this trend is reverted and best OLTP performance can be attained with smaller page sizes; (b) DBMS with smaller page ...

متن کامل

Optimize write performance for DBMS on Solid State Drive

Solid State Drive (SSD) is believed to be the replacement for magnetic disk in computer systems. SSD is a complex storage device composed of flash chips, controller hardware, and proprietary software that together provide a block device interface via a standard interconnect. Comparing to its fast sequential read/write and random read operations, the random write on SSD is generally believed to ...

متن کامل

Page Size Selection for OLTP Databases on SSD Storage

Flash SSDs are a technology that has the potential of changing the database architecture and principles. We reevaluate present trend of growing database page sizes considering its validity for SSD-based database storage. Our major findings are: (a) on Flash storage this trend is reverted and best OLTP performance can be attained with smaller page sizes; (b) DBMS with smaller page sizes require ...

متن کامل

RFLRU: A Buffer Cache Management Algorithm for Solid State Drive to Improve the Write Performance on Mixed Workload

Flash memory based Solid State Drives (SSD) acquiring greater attention in enterprise storage computing environment; this is primarily due to its high I/O speed. SSDs use multiple NAND flash memory chips as a storage media and deploy internal RAM to maintain the flash translation layer (FTL) mapping table. The rest portion of the inner RAM is used as a buffer. This buffer absorbs the write requ...

متن کامل

ذخیره در منابع من


  با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید

عنوان ژورنال:

دوره   شماره 

صفحات  -

تاریخ انتشار 2009